TYPE=VIEW
query=select distinct `luanvan`.`monhocs`.`mamon` AS `mamon`,`luanvan`.`monhocs`.`tenmon` AS `tenmon`,`luanvan`.`monhocs`.`sotc` AS `sotc`,`luanvan`.`hknks`.`hknk` AS `hknk`,`luanvan`.`lophps`.`sinhvien_id` AS `sinhvien_id`,`luanvan`.`lophps`.`malophp` AS `malophp`,`luanvan`.`lophps`.`id` AS `id` from ((`luanvan`.`monhocs` join `luanvan`.`lophps` on((`luanvan`.`monhocs`.`id` = `luanvan`.`lophps`.`monhoc_id`))) join `luanvan`.`hknks` on((`luanvan`.`hknks`.`id` = `luanvan`.`lophps`.`hknk_id`)))
md5=70fc865593b7f5639f05784cfefbae81
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-03-24 16:00:41
create-version=1
source=Select Distinct monhocs.mamon,\n  monhocs.tenmon,\n  monhocs.sotc,\n  hknks.hknk,\n  lophps.sinhvien_id,\n  lophps.malophp,\n  lophps.id\nFrom monhocs Inner Join\n  lophps On monhocs.id = lophps.monhoc_id Inner Join\n  hknks On hknks.id = lophps.hknk_id
client_cs_name=utf8
connection_cl_name=utf8_unicode_ci
view_body_utf8=select distinct `luanvan`.`monhocs`.`mamon` AS `mamon`,`luanvan`.`monhocs`.`tenmon` AS `tenmon`,`luanvan`.`monhocs`.`sotc` AS `sotc`,`luanvan`.`hknks`.`hknk` AS `hknk`,`luanvan`.`lophps`.`sinhvien_id` AS `sinhvien_id`,`luanvan`.`lophps`.`malophp` AS `malophp`,`luanvan`.`lophps`.`id` AS `id` from ((`luanvan`.`monhocs` join `luanvan`.`lophps` on((`luanvan`.`monhocs`.`id` = `luanvan`.`lophps`.`monhoc_id`))) join `luanvan`.`hknks` on((`luanvan`.`hknks`.`id` = `luanvan`.`lophps`.`hknk_id`)))
